STA 141 B Final Project

Yixiang Cheng, Gracy Chen, Ziqi Dai

Introduction

In this project, our team want to analysis the Impact of covid 19 and the effective of vaccination on the new cases and death case of covid 19,

Crawl Data From Websites API

Data Munging

Create SQL storage for dataset

Data Visualization

From the two plots we can know that when the vaccination is started, the number of new infections begins to decline, which is in line with normal expectations, that is, the vaccine has a certain effect on COVID-19.

As can be seen in the chart above, California had the highest number of infected and vaccinated people on the last day of data collection.

The chart shows the development of the epidemic situation from three dimensions of time, location and number of new infections. It can be seen that no matter in any state, the number of new infections was better controlled on the last day of statistics than before.